2017-01-10 - 28540 - Break Fix - ZSD_VPRS_UPDATE Short Dump Bug Fix #MMPPSupport #SDSupportBilling
2017-01-10 - 28540 - Break Fix - ZSD_VPRS_UPDATE
Problem Summary
COPA_VPRS_CORRECTION failed due to ABAP short dump.
Admin Info
Purpose
|
COPA_VPRS_CORRECTION short dump.
|
Requested by
|
Jingsha
|
Issue Date
|
01-03-2017
|
Resolved by
|
Damodhier
|
Resolved Date
|
01-12-2017
|
Document Status
|
Complete
|
Detailed Problem Description
(Include Screen Shots if required )
Job COPA_VPRS_CORRECTION is failed due to dump on date 01/03/2017.
There are Two steps in the Job:
1. ZSD_VPRS_UPDATE - This is a custom program which shall collect the list of Invoices and update this in TVARVC table with variable ‘VPRSUPDATE’.
2. SDVPRSUPDATE - This is a standard program which shall update VPRS price in the Invoices from TVARVC table.
Short dump was due to a bug in the program when fetching the data from the VBFA when there are no TAS orders created with the conditions in the program.
Solution Analysis and Recommendations
(Include Screen Shots if required)
Logic of ZSD_VPRS_UPDATE
1. Get data BELNR from RBKP Table based on the given input (Fiscal Year, Document Type, and Created Date).
2. PASS BELNR in to EKBE table with inputs Invoice Receipt (EKBE-VGABE = 2), Fiscal Year (given in program input) and get EBELN.
3. PASS EBELN in to VBFA table with Order input (VBTYP_V = C) and get VBELV
4. PASS VBELV in to VBAP table in field VBELN with Item Category ‘TAS’
5. PASS VBELN in to VBFA table with Invoice (VBTYP_N = M)
Delete already existing data from TVARVC variable ‘VPRSUPDATE’ and add the data which was fetched from the table VBFA in the above step 5.
Job Failure on 01/03/2017 due to:
In Step 4 as there were no entries, due to bug in program in 5th step it fetched the entire data and updated in to TVARVC table.
The Program updated more than 10,000 entries in to TVARVC and when those 10,000 entries are given in input there was a short dump.
If there are TAS orders Bug would not effect to dump.
Resolution
Added logic in program ZSD_VPRS_UPDATE to restrict fetching of entire data whenever there are no TAS orders.
Release Information
Provide link here to Release Notes if Technical Objects were changed
2017-01-20 - 28540 - Rel Notes - ZSD_VPRS_UPDATE Short Dump Bug Fix